BEGIN TRANSACTION GO ALTER TABLE dbo.gen_ProductsInfo ADD UnitPrice2 numeric(12, 3) NOT NULL CONSTRAINT DF_gen_ProductsInfo_UnitPrice2 DEFAULT 0, SalePrice2 numeric(12, 3) NOT NULL CONSTRAINT DF_gen_ProductsInfo_SalePrice2 DEFAULT 0, Weight numeric(12, 3) NOT NULL CONSTRAINT DF_gen_ProductsInfo_Weight DEFAULT 0, InQty numeric(12, 3) NOT NULL CONSTRAINT DF_gen_ProductsInfo_StockIn DEFAULT 0, OutQty numeric(12, 3) NOT NULL CONSTRAINT DF_gen_ProductsInfo_OutQty DEFAULT 0, BalQty numeric(12, 3) NOT NULL CONSTRAINT DF_gen_ProductsInfo_BalQty DEFAULT 0 GO COMMIT ---------------------------- BEGIN TRANSACTION GO ALTER TABLE dbo.gen_PartiesInfo ADD CrLimit numeric(15, 2) NOT NULL CONSTRAINT DF_gen_PartiesInfo_CrLimit DEFAULT 0, Balance numeric(15, 2) NOT NULL CONSTRAINT DF_gen_PartiesInfo_Balance DEFAULT 0 GO COMMIT ----------------------------